PK
.MXë $ $ ,
Table_ExtendedTestOfWeirdBuckets_meta.sqliteUT ffSQLite format 3 @ -
# 1
table_extended.txtputAղ!rP
r11
table_extended.txtETag: "2bda78b8b26cd1b74f27071c3826ba30"
accept: */*
accept-encoding: gzip, deflate, sdch
accept-language: en-US,en;q=0.8,de-DE;q=0.6,de;q=0.4
authorization: LOW s6XZuf8L6MionO98:REDACTED_BY_IA_S3
cache-control: no-cache
c
1 table_extended.txt
H Hpu %99etables3item_pending_changess3item_pending_changesCREATE TABLE s3item_pending_changes
(
sequence_number INTEGER PRIMARY KEY ASC,
op blob,
args blob,
time float,
done int default 0
)))?tables3item_historys3item_historyCREATE TABLE s3item_history
(
sequence_number INTEGER PRIMARY KEY ASC,
key blob,
op blob,
data blob,
time float
);99tables3api_per_key_metadatas3api_per_key_metadataCREATE TABLE s3api_per_key_metadata
(
s3key blob,
headers blob,
live_date real,
old_version_of blob,
primary key (s3key),
unique (s3key)
)K_9 indexsqlite_autoindex_s3api_per_key_metadata_1s3api_per_key_metadata onnection: close
content-length: 9517
content-type: multipart/form-data; charset=UTF-8
host: s3.us.archive.org
origin: https://archive.org
referer: https://archive.org/upload/
user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.80 Safari/537.36
x-amz-acl: bucket-owner-full-control
x-amz-auto-make-bucket: 1
x-archive-interactive-priority: 1
x-archive-meta-mediatype: uri(texts)
x-archive-meta01-collection: uri(opensource)
x-archive-meta01-description: uri(there%20seems%20to%20be%20a%20bug%20in%20most%20s3%20tools%20that%20upper%20case%20names%20are%20not%20supported)
x-archive-meta01-scanner: uri(Internet%20Archive%20HTML5%20Uploader%201.6.3)
x-archive-meta01-subject: uri(archive.org)
x-archive-meta01-title: uri(Table_Extended)
x-archive-meta02-subject: uri(bug)
x-archive-size-hint: 9517
x-file-name: uri(table_extended.txt)
x-file-size: 9517
x-ias3-encoded-key: table_extended.txt
x-requested-with: XMLHttpRequest
x-upload-date: 2016-02-20T15:20:33.000Z
Aղ!C PK
.MX]--% -%
table_extended.txtUT fftableName:github_projects
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive
inputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat
outputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:2
totalFileSize:2043645651
maxFileSize:2043645374
minFileSize:277
lastAccessTime:0
lastUpdateTime:1455974890000
before:
tableName:github_projects_asnappy
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_asnappy
inputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat
outputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:199
totalFileSize:2135894040
maxFileSize:16810864
minFileSize:10615104
lastAccessTime:0
lastUpdateTime:1455966332000
SET hive.exec.compress.output=true;
SET mapred.output.compression.type=BLOCK;
SET mapred.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec;
set hadoop.tmp.dir=/mnt/data/home/mdupont/oel/data/github/hive/temp;
set hive.metastore.warehouse.dir=/mnt/data/home/mdupont/oel/data/github/hive/;
SET dfs.block.size=10240000;
SET parquet.block.size=10240000;
SET hive.exec.reducers.bytes.per.reducer=10240000;
SET hive.merge.mapfiles=true;
SET hive.merge.size.per.task=10240000;
SET hive.merge.smallfiles.avgsize=10240000;
SET mapred.max.split.size=10240000;
INSERT OVERWRITE TABLE github_projects_asnappy SELECT * FROM github_projects_asnappy;
Afterwards :
tableName:github_projects_asnappy
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_asnappy
inputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat
outputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:66
totalFileSize:742289940
maxFileSize:20089860
minFileSize:10219088
lastAccessTime:0
lastUpdateTime:1455977735000
tableName:github_projects_az
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_az
inputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat
outputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:199
totalFileSize:2135893045
maxFileSize:16810859
minFileSize:10615099
lastAccessTime:0
lastUpdateTime:1455935348000
tableName:github_projects_az2
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_az2
inputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat
outputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:199
totalFileSize:2135893244
maxFileSize:16810860
minFileSize:10615100
lastAccessTime:0
lastUpdateTime:1455964350000
tableName:github_projects_az3
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_az3
inputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat
outputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:67
totalFileSize:742307235
maxFileSize:13416052
minFileSize:3822060
lastAccessTime:0
lastUpdateTime:1455964955000
tableName:github_projects_az4
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_az4
inputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat
outputformat:org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:199
totalFileSize:2135893244
maxFileSize:16810860
minFileSize:10615100
lastAccessTime:0
lastUpdateTime:1455965287000
tableName:github_projects_pgz
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_pgz
inputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat
outputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:67
totalFileSize:902523166
maxFileSize:13993256
minFileSize:9044963
lastAccessTime:0
lastUpdateTime:1455933960000
tableName:github_projects_ps
archive.org:OelGithubProjectsParquetSnappy
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_ps
inputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat
outputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:597
totalFileSize:4406505316
maxFileSize:16645387
minFileSize:3926751
lastAccessTime:0
lastUpdateTime:1455931502000
tableName:github_projects_ps2
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_ps2
inputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat
outputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:1
totalFileSize:14799512
maxFileSize:14799512
minFileSize:14799512
lastAccessTime:0
lastUpdateTime:1455882346000
tableName:github_projects_ps3
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_ps3
inputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat
outputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:1
totalFileSize:15450
maxFileSize:15450
minFileSize:15450
lastAccessTime:0
lastUpdateTime:1455883550000
tableName:github_projects_ps4
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_ps4
inputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat
outputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat
columns:struct columns { i32 id, string owner_type, string name, string description, string full_name, string owner_name, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:1
totalFileSize:15347
maxFileSize:15347
minFileSize:15347
lastAccessTime:0
lastUpdateTime:1455883924000
tableName:github_projects_pssn
ARCHIVE.ORG:oel_github_projects_snappy_hive
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_pssn
inputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat
outputformat:org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:100
totalFileSize:1417888955
maxFileSize:14625414
minFileSize:11271128
lastAccessTime:0
lastUpdateTime:1455932360000
TEXT
tableName:github_projects_t
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_t
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:398
totalFileSize:2823081536
maxFileSize:16943171
minFileSize:2879187
lastAccessTime:0
lastUpdateTime:1455935970000
tableName:github_projects_i
owner:mdupont
location:file:/mnt/data/home/mdupont/oel/data/github/hive/github_projects_i
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { i32 id, bool fork, string name, string description, string full_name, string owner_name, string owner_type, string html_url}
partitioned:false
partitionColumns:
totalNumberFiles:7
totalFileSize:2152276311
maxFileSize:534169493
minFileSize:269407793
lastAccessTime:0
lastUpdateTime:1455794982000
PK
.MXrp3 *
Table_ExtendedTestOfWeirdBuckets_files.xmlUT ff
28be25e30602f9594415b5b2175e45e36dbc9dc4
1613714328
1799
14b941e7ecc75134008e1974f6439f5f
b440df77
d7e6c19a55b6526c39b64664984d59e53681bd53
Archive BitTorrent
Metadata
9b4cae1ef6003077230306dd1ec0a402
md5
1455981646
9216
5422538bc3dd19e00bb9f18d878b16fb
abc3b2f5
4d4908b823672b421cb96fd7158693a5d72e1427
Metadata
1613714327
999
Metadata
8c57e82c1e1cd199aa72a49239bac03e
6c5abf60
edcd8876f4600727e7380121fb9c23f7d4215c9a
1455981633
9517
2bda78b8b26cd1b74f27071c3826ba30
2d5d90e0
11d0020dd025a6cd7ed18569ed7443f9700fd369
Text
PK
.MX`Zl )
Table_ExtendedTestOfWeirdBuckets_meta.xmlUT ff
Table_ExtendedTestOfWeirdBuckets
data
opensource_media
there seems to be a bug in most s3 tools that upper case names are not supported
Internet Archive HTML5 Uploader 1.6.3
archive.org
Table_Extended
bug
2016-02-20 15:20:35
jamesmikedupont@gmail.com
2016-02-20 15:20:35
[curator]validator@archive.org[/curator][date]20160220152053[/date][comment]checked for malware[/comment]
http://archive.org/details/Table_ExtendedTestOfWeirdBuckets
ark:/13960/t2n62rk18
4
ia906100_21
community
PK
.MXw@ 0
Table_ExtendedTestOfWeirdBuckets_archive.torrentUT ffd8:announce36:http://bt1.archive.org:6969/announce13:announce-listll36:http://bt1.archive.org:6969/announceel36:http://bt2.archive.org:6969/announceee7:comment686:This content hosted at the Internet Archive at https://archive.org/details/Table_ExtendedTestOfWeirdBuckets
Files may have changed, which prevents torrents from downloading correctly or completely; please check for an updated torrent at https://archive.org/download/Table_ExtendedTestOfWeirdBuckets/Table_ExtendedTestOfWeirdBuckets_archive.torrent
Note: retrieval usually requires a client that supports webseeding (GetRight style).
Note: many Internet Archive torrents contain a 'pad file' directory. This directory and the files within it may be erased once retrieval completes.
Note: the file Table_ExtendedTestOfWeirdBuckets_meta.xml contains metadata about this torrent's contents.10:created by15:ia_make_torrent13:creation datei1613714328e4:infod11:collectionsl44:org.archive.Table_ExtendedTestOfWeirdBucketse5:filesld5:crc328:abc3b2f56:lengthi9216e3:md532:5422538bc3dd19e00bb9f18d878b16fb5:mtime10:14559816464:pathl44:Table_ExtendedTestOfWeirdBuckets_meta.sqlitee4:sha140:4d4908b823672b421cb96fd7158693a5d72e1427ed5:crc328:6c5abf606:lengthi999e3:md532:8c57e82c1e1cd199aa72a49239bac03e5:mtime10:16137143274:pathl41:Table_ExtendedTestOfWeirdBuckets_meta.xmle4:sha140:edcd8876f4600727e7380121fb9c23f7d4215c9aed5:crc328:2d5d90e06:lengthi9517e3:md532:2bda78b8b26cd1b74f27071c3826ba305:mtime10:14559816334:pathl18:table_extended.txte4:sha140:11d0020dd025a6cd7ed18569ed7443f9700fd369ee4:name32:Table_ExtendedTestOfWeirdBuckets12:piece lengthi524288e6:pieces20:Q;S+S®D[e6:locale2:en5:title32:Table_ExtendedTestOfWeirdBuckets8:url-listl29:https://archive.org/download/40:http://ia600203.us.archive.org/35/items/10:/35/items/eePK-
.MXë $ $ , @ Table_ExtendedTestOfWeirdBuckets_meta.sqliteUT fPK-
.MX]--% -% @W$ table_extended.txtUT fPK-
.MXrp3 * @I Table_ExtendedTestOfWeirdBuckets_files.xmlUT fPK-
.MX`Zl ) @O Table_ExtendedTestOfWeirdBuckets_meta.xmlUT fPK-
.MXw@ 0 @7T Table_ExtendedTestOfWeirdBuckets_archive.torrentUT fPK [